• Monitor for Hung SQL Server Agent Jobs

    Updated: 2023-11-30 05:00:00
    In this article, we look at setting up an automated process to alert you about long-running SQL Server Agent jobs and the ability to stop the job if needed.

  • Getting Started with Microsoft Power BI Training

    Updated: 2023-11-30 05:00:00
    Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.

  • Microsoft Fabric: Extended Source Control Features

    Updated: 2023-11-29 17:00:00
    The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for Power BI, supporting reports and datasets linked directly from the portal to a repository. The New Source Control Features Recently, without much news, Microsoft extended the … The post Microsoft Fabric: Extended Source Control Features appeared first on Simple Talk.

  • Limit Data Scanning and Excess Query Plans in Amazon Athena

    Updated: 2023-11-29 05:00:00
    Learn how to manage and control the amount of data used for Amazon Athena queries to limit excessive query runs.

  • Area Chart in Power BI to Understand Data Changes Over Time

    Updated: 2023-11-28 05:00:00
    Learn how to create an area chart in Power BI to understand the intensity of a change and cumulative total values over time along with the different available formatting options.

  • What are Kusto Query Language (KQL) databases in Microsoft Fabric?

    Updated: 2023-11-28 05:00:00
    Learn how to get started with the KQL database service in Microsoft Fabric. KQL databases are a continuation of Azure Data Explorer (or Synapse Kusto Pools) in Fabric. They allow you to perform time-series analysis on large amounts of data, and KQL databases can ingest streaming data as well.

  • Solving Date Range SQL Server Query Performance Issues with OPTION RECOMPILE

    Updated: 2023-11-27 05:00:00
    In this article, I demonstrate the issue of creating two SQL Server indexes to enhance performance, but the query optimizer only chooses one which doesn't help with performance.

  • When an update doesn’t update

    Updated: 2023-11-27 00:38:59
    Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database, I couldn’t see the change! I’ve seen this. Loads. It can be quite perplexing for folks because they expect to see an error message if the insert, update, or delete failed. I put this post … The post When an update doesn’t update appeared first on Simple Talk.

  • Warehouse Load Patterns – Part 1 – Requirements and General Patterns

    Updated: 2023-11-26 21:45:52
    No matter the ETL tool used, there are some basic patterns to follow when transferring data between systems. There are many data tools and platforms, but the basic patterns remain the same. This focuses on SQL Server, but most of these methods work in any data platform. Even if you are using a virtualization layer, … The post Warehouse Load Patterns – Part 1 – Requirements and General Patterns appeared first on Simple Talk.

  • Updates about Database Projects for Microsoft Fabric

    Updated: 2023-11-26 17:39:47
    comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an interesting advance, but it was disappointing because it was only available in half. Updating the Fabric Data Warehouse was not possible yet. The November updates for Microsoft Fabric announces the support for SQLPackage, but I couldn’t find additional … The post Updates about Database Projects for Microsoft Fabric appeared first on Simple Talk.

  • Login flow in R12.2 and basic troubleshooting

    Updated: 2023-11-25 04:49:00
    R12.2 is the latest Release of Oracle E-business Suite Products. Here we will be discussing the Login flow in R12.2 and how to troubleshoot login issues in R12.2 Login flow in R12.2 Here is the processing in terms of URL(Login HTTP headers) When the EBS login works OK, the browser will be redirected to various […] The post Login flow in R12.2 and basic troubleshooting appeared first on Techgoeasy.

  • Docker Security Principles Overview

    Updated: 2023-11-24 16:03:35
    Docker is an open-source platform that enables developers to automate the deployment and management of applications using containerization. It was created by Solomon Hykes and his team at Docker, Inc., and was first released in 2013. Docker allows developers to package their applications and their dependencies into lightweight, portable containers that can run consistently across … The post Docker Security Principles Overview appeared first on Simple Talk.

  • How To Retrieve Instance Metadata from Server

    Updated: 2023-11-24 07:56:27
    Skip to primary navigation Skip to main content Skip to primary sidebar Techgoeasy Learn Oracle , PHP , HTML,CSS,Perl,UNIX shell scripts Home Oracle database Oracle Ebusiness Suite Oracle weblogic Oracle Performance Tuning Oracle Hyperion Oracle Cloud Tutorials SQL interview questions Linux PHP and HTML Downloads Home » Oracle » Oracle cloud » How To Retrieve Instance Metadata from Server How To Retrieve Instance Metadata from Server November 24, 2023 by techgoeasy Leave a Comment We can retrieve Instance Metadata like OCID , Display Name , Region , Availability Domain , Fault domain , Compartment OCID , Instance shape , Subnet CIDR , etc in three . ways Using oci-metadata With Linux7, The oci-metadata utility is used to display or update metadata for a compute instance running in the

  • How to delete the archive logs in Oracle

    Updated: 2023-11-24 03:51:00
    Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on […] The post How to delete the archive logs in Oracle appeared first on Techgoeasy.

  • How to check block corruption in Oracle database and Fix it

    Updated: 2023-11-22 18:00:00
    Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to […] The post How to check block corruption in Oracle database and Fix it appeared first on Techgoeasy.

  • MB-260 Microsoft Customer Data Platform Specialist Exam Preparation

    Updated: 2023-11-22 05:00:00
    Prepare for the MB-260 Microsoft Customer Data Platform Specialist Exam with the resources in this article.

  • How To Backup Database To Cloud Object Storage Using DBCLI

    Updated: 2023-11-21 16:56:00
    We have automatic backup in DBCS which is managed by Oracle. The customer does not have any control over the bucket and we dont have enough flexibility. we can schedule the custom backup using dbcli to our bucket in our tenancy This will give more control over the backup and we can do replication to […] The post How To Backup Database To Cloud Object Storage Using DBCLI appeared first on Techgoeasy.

  • Exploring a Recursive Common Table Expression in SQL Server with Examples

    Updated: 2023-11-21 05:00:00
    Learn how to write and use recursive CTEs in SQL Server along with explanations and several examples.

  • Strategies for queries against bit columns

    Updated: 2023-11-20 16:13:08
    Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based on a bit parameter. They tried to write a procedure like this, which wouldn’t parse, of course: I explained that you can’t have control-of-flow inside a SQL statement like that, at least not in T-SQL. And that the … The post Strategies for queries against bit columns appeared first on Simple Talk.

  • How to configure Automatic Managed backup on DBCS

    Updated: 2023-11-20 14:16:00
    Oracle Provides Automatic Managed Backup Service on DBCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy How to configure Automatic Managed Backup Step 1Open the navigation menu. Under Oracle Database, click Base Database service.Step 2Choose your Compartment.A list of […] The post How to configure Automatic Managed backup on DBCS appeared first on Techgoeasy.

  • Content Management System Architecture

    Updated: 2023-11-17 19:49:55
    A Content Management System (CMS) is a software application that allows users to handle digital content on a website without specialized technical knowledge. It provides an intuitive interface for non-technical users to add, edit, and organize content such as text, images, videos, and other multimedia elements. The generation and broad distribution of website content can … The post Content Management System Architecture appeared first on Simple Talk.

  • Learn Spark SQL Date and Time Functions

    Updated: 2023-11-17 05:00:00
    This article covers how to use the different date and time functions when working with Spark SQL with several different examples of how to use these date/time functions.

  • How to install SQL Server 2022 step by step

    Updated: 2023-11-17 05:00:00
    In this article, we cover how to install SQL Server 2022.

  • LLMOps and Model Tracking with MLFlow with Open AI

    Updated: 2023-11-16 05:00:00
    This article demonstrates how easy it is to get started with LLMOps with MLFlow for Model Tracking. It describes how to begin creating your custom models from base models available through the Open AI API.

  • PowerShell Commands to Administer Virtual Machines on Amazon AWS - Part 2

    Updated: 2023-11-15 05:00:00
    Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.

  • Array Based Snapshots for the SQL Server DBA

    Updated: 2023-11-14 05:00:00
    In this article, you will learn about the different types of snapshots and why every DBA should consider them for their tool arsenal.

  • TABLOCK Hint can Negatively Impact SQL Server Concurrency

    Updated: 2023-11-13 05:00:00
    In this article, we look at how using the Tablock hint in SQL Server could impact concurrency and block other sessions.

  • Solving SQL Server Performance Issues for 18 Years and Counting

    Updated: 2023-11-13 05:00:00
    Over the years, SQL Sentry became integral to a DBA's toolkit for resolving SQL Server performance issues. Recently, additional features have been introduced that can truly benefit DBAs globally.

  • SQL Date Format Options with SQL CONVERT Function

    Updated: 2023-11-13 05:00:00
    Learn SQL date format options with the SQL CONVERT function when working with date data types in SQL Server.

  • Unicode: Code Points in SQL or PL/SQL

    Updated: 2023-11-11 13:12:08
    A new topic has been added to the Unicode section on SQL Snippets. "Code Points in SQL or PL/SQL" examines various techniques for determining a character's Unicode code point. One technique involves creating a custom PL/SQL function called UNICODEPOINT(). When compared to other techniques UNICODEPOINT() proves to be faster, leaner, and more scalable. It also works on more Oracle versions than the other techniques....

  • SQL Features Tutorials: Unicode

    Updated: 2023-11-11 13:12:07
    A new section on Unicode has been added to SQL Snippets. Topics covered include a practical overview of Unicode Unicode support in Oracle working with Unicode data in UNIX and Windows XP operating systems viewing Unicode data in Excel 2007, Firefox, Internet Explorer, Notepad, PuTTY, SQL Developer, and SQL*Plus transferring Unicode data with WinSCP and ftp....

  • Joe's Blog: 15 Mintues of Fame

    Updated: 2023-11-11 13:12:07
    : SQL Snippets Tutorials for Oracle Developers Custom Search Home A0 A0 SQL Features A0 A0 SQL Techniques A0 A0 Miscellany A0 A0 About A0 A0 Blog A0 A0 Site Map A0 A0 Search A0 A0 Home Blog A0 15 Minutes of Fame A0 Happy First Anniversary SQL Snippets A0 And Now for Something Completely Different A0 Google Street View A0 Getting IT Right A0 The Task Spiral A0 The Choice A0 It's Alive A0 Snippets in the Strangest Places A0 The Journey Begins A0 About the Author A0 Next A0 Read Using SQL Snippets before using any of this site's sample code or techniques on your own . systems Joe's Blog 15 Mintues of Fame 2009-07-25 They say everyone gets at least 15 minutes of fame in their lifetime . Here's my total to-date . 1 minute Middle School my picture and some artwork appeared in The Toronto Star

  • SQL Features Tutorials: Grouping Rows with GROUP BY

    Updated: 2023-11-11 13:12:07
    A new tutorial has been added to SQL Snippets exploring the GROUP BY clause and related extensions such as GROUPING SETS, ROLLUP, and CUBE. Group related functions such as GROUP_ID, GROUPING, and GROUPING_ID are also covered....

  • Columns to String: Comma Separated Values (CSV)

    Updated: 2023-11-11 13:12:07
    The "Columns to String: Comma Separated Values (CSV)" tutorial now includes three new sections, "How to Create a CSV File", "How to Escape Double Quotes, CR, and LF", and "How to Include a Header Line"....

  • SQL Features Tutorials: Materialized Views

    Updated: 2023-11-11 13:12:06
    Originally introduced in 1992 as "Snapshots" in Oracle 7, Materialized Views are now used in ways far removed from their original raison d'être, replication. Database programmers use them for data warehousing, denormalization, and even validation. Despite their versatility though, materialized views remain a mystery to some programmers due to their complexity. The new SQL Snippets tutorial "Materialized Views" strips away the mystery with its simple test cases, step-by-step exploration of the basics, common programming pitfall alerts, and a useful utility called MY_MV_CAPABILITIES which analyzes and reports a materialized view's capabilities in a single step....

  • Regular Expressions: REGEXP_COUNT

    Updated: 2023-11-11 13:12:06
    Introduced in Oracle 11g the REGEXP_COUNT function greatly simplifies counting the number of times a pattern appears inside a string. The following examples demonstrate how to use REGEXP_COUNT with some simple patterns. For versions prior to 11g alternative logic that provides similar functionality is also presented....

  • SQL Techniques Tutorials: Rows to Columns

    Updated: 2023-11-11 13:12:06
    The SQL Snippets "Rows to Columns" tutorial has been updated to include solutions that use the new 11g PIVOT clause of the SELECT command....

  • Nulls: Nulls and Equality

    Updated: 2023-11-11 13:12:05
    The SQL Snippets "Nulls and Equality" tutorial has been updated with new solutions and a discussion about the undocumented SYS_OP_MAP_NONNULL function....

  • Joe's Blog: Happy First Anniversary SQL Snippets!

    Updated: 2023-11-11 13:12:05
    : SQL Snippets Tutorials for Oracle Developers Custom Search Home A0 A0 SQL Features A0 A0 SQL Techniques A0 A0 Miscellany A0 A0 About A0 A0 Blog A0 A0 Site Map A0 A0 Search A0 A0 Home Blog A0 15 Minutes of Fame A0 Happy First Anniversary SQL Snippets A0 And Now for Something Completely Different A0 Google Street View A0 Getting IT Right A0 The Task Spiral A0 The Choice A0 It's Alive A0 Snippets in the Strangest Places A0 The Journey Begins A0 About the Author A0 Next A0 Read Using SQL Snippets before using any of this site's sample code or techniques on your own . systems Joe's Blog Happy First Anniversary SQL Snippets 2007-11-18 Well , it's been exactly one year since SQL Snippets first appeared on the web as a prototype site containing 33 pages viewed by a handful of visitors in its

  • Columns to Rows: UNPIVOT (11g)

    Updated: 2023-11-11 13:12:05
    SQL Snippets "Columns to Rows" section has been expanded to include a topic on using Oracle 11g's new UNPIVOT clause, which makes all prior techniques for transforming columns into rows now obsolete....

  • Nulls: Nulls and Aggregate Functions

    Updated: 2023-11-11 13:12:05
    A new tutorial has been added to SQL Snippets which demonstrates how aggregate functions deal with null values. Techniques for generating results that ignore nulls and results that include nulls are highlighted....

  • Integer Series Generators: Multiple Integer Series

    Updated: 2023-11-11 13:12:04
    The SQL Snippets "Integer Series Generator" section has been expanded to include new topics covering techniques for generating multiple integer series in a single query. Unlike previous topics which only demonstrated queries that created a single integer series, like 1,2,3,4, the new topics show how a query can generate a series like 1,2 for one row and 1,2,3 for another row in the same query....

  • String to Rows: Hierarchical Methods

    Updated: 2023-11-11 13:12:04
    A new, hierarchical technique for converting strings to rows has been added to the SQL Techniques Tutorials - String to Rows tutorial in SQL Snippets....

  • Integer Series Generators: CONNECT BY LEVEL Method

    Updated: 2023-11-11 13:12:04
    This tutorial has been updated to include a discussion of how hierarchical queries that do not have a CONNECT BY condition with PRIOR behave. A sample query that uses "PRIOR DBMS_RANDOM.VALUE IS NOT NULL" to make the CONNECT BY LEVEL technique conform to documented requirements has also been added....

  • SQL Techniques Tutorials: Pattern Matching Over Rows

    Updated: 2023-11-11 13:12:04
    : SQL Snippets Tutorials for Oracle Developers Custom Search Home A0 A0 SQL Features A0 A0 SQL Techniques A0 A0 Miscellany A0 A0 About A0 A0 Blog A0 A0 Site Map A0 A0 Search A0 A0 Home SQL Techniques Pattern Matching Over Rows A0 String Aggregation A0 Finding Patterns using REGEXP Functions A0 Measures A0 Setup A0 Cleanup A0 A0 Next A0 Read Using SQL Snippets before using any of this site's sample code or techniques on your own . systems Pattern Matching Over Rows This topic was inspired by Tom Kyte's So , in your opinion blog post about a new SQL feature Oracle is considering described at Pattern matching in sequences of rows I'll admit I've never tackled this kind of pattern matching before and I didn't understand the entire paper . It's a pretty dense read . From what I can tell though

  • SQL Techniques Tutorials: Varying IN Lists

    Updated: 2023-11-11 13:12:03
    This new SQL Snippets tutorial explores different approaches for implementing varying IN lists, including ones that use LIKE, MODEL, and integer series generator logic. The solutions will be presented as SQL commands, but the logic can be easily implemented in PL/SQL functions if required. ...

  • Joe's Blog: And Now for Something Completely Different

    Updated: 2023-11-11 13:12:03
    : SQL Snippets Tutorials for Oracle Developers Custom Search Home A0 A0 SQL Features A0 A0 SQL Techniques A0 A0 Miscellany A0 A0 About A0 A0 Blog A0 A0 Site Map A0 A0 Search A0 A0 Home Blog A0 15 Minutes of Fame A0 Happy First Anniversary SQL Snippets A0 And Now for Something Completely Different A0 Google Street View A0 Getting IT Right A0 The Task Spiral A0 The Choice A0 It's Alive A0 Snippets in the Strangest Places A0 The Journey Begins A0 About the Author A0 Next A0 Read Using SQL Snippets before using any of this site's sample code or techniques on your own . systems Joe's Blog And Now for Something Completely Different 2007-06-28 Every once in a while my non-programmer friends give me feedback about my site like the blog posts are good , but when it comes to all that SQL stuff ,

  • Joe's Blog: Google Street View

    Updated: 2023-11-11 13:12:03
    : SQL Snippets Tutorials for Oracle Developers Custom Search Home A0 A0 SQL Features A0 A0 SQL Techniques A0 A0 Miscellany A0 A0 About A0 A0 Blog A0 A0 Site Map A0 A0 Search A0 A0 Home Blog A0 15 Minutes of Fame A0 Happy First Anniversary SQL Snippets A0 And Now for Something Completely Different A0 Google Street View A0 Getting IT Right A0 The Task Spiral A0 The Choice A0 It's Alive A0 Snippets in the Strangest Places A0 The Journey Begins A0 About the Author A0 Next A0 Read Using SQL Snippets before using any of this site's sample code or techniques on your own . systems Joe's Blog Google Street View 2007-06-08 Here's something cool . A new Google Maps feature called Street View is available for some streets . With it you can virtually walk down a road seeing actual street level

  • Git Integration Repo in Databricks Workspaces for Developer Collaboration

    Updated: 2023-11-10 05:00:00
    With the introduction of Git Integration Repo in Databricks workspaces, a developer can now collaborate with other developers for their data projects.

  • Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY

    Updated: 2023-11-08 05:00:00
    Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.

  • Query Amazon CloudTrail Logs using Amazon Athena for AWS Account Auditing

    Updated: 2023-11-07 05:00:00
    This tip covers using Amazon Athena to query Amazon CloudTrail logs for auditing your AWS account.

  • Step-by-step Installation of SQL Server 2022 on a Windows Server 2022 Failover Cluster - Part 1

    Updated: 2023-11-06 05:00:00
    Learn how to build a Windows Failover Cluster using Windows 2022 and SQL Server 2022 in this step-by-step series.

  • New Power BI DAX Functions - RANK and ROWNUMBER

    Updated: 2023-11-06 05:00:00
    This tip will provide fundamental information on RANK and ROWNUMBER functions, two new DAX functions available in Power BI.

  • Getting Started with Databricks Unity Catalog and Volumes

    Updated: 2023-11-03 05:00:00
    In this article, we look at how to get started with Databricks Unity Catalog and Volumes in this step-by-step overview.

Current Feed Items | Previous Months Items

Oct 2023 | Sep 2023 | Aug 2023 | Jul 2023 | Jun 2023 | May 2023